Update your query like this and try: ps_cursor.execute(''' SELECT * FROM "posts" ) ORDER BY "posts"."rate" {0}, "posts"."date_created" ASC ... ... <看更多>

ORDER BY ASC / DESC I SQL query to sort columns in ascending and descending order in MySql, SqlServer. TechGeekyArti. TechGeekyArti. ... <看更多>

Sort Array in javascript by ASC or DESC . GitHub Gist: instantly share code, notes, and snippets. ... <看更多>

Ideal for those queries would be in index on (court_id, id) , and with the columns in that order. It should be extremely fast in either ... ... <看更多>